Incorrect data might occur when you use explicit pass-through with SAS/ACCESS® Interface to DB2 in a z/OS operating environment. The incorrect data occurs when DB2 returns a warning due to an arithmetic exception; for example, a division by zero.
To determine what the DB2 warning was, do one of the following: Either take the query and run it outside of SAS using something like SPUFI (SQL processor using file input), or do a Call Attachment Facility (CAF) trace by allocating a DSNTRACE data set and look in the generated trace messages for an SQLCODE that is not equal to 0.
To work around this issue, fix the code that led to the arithmetic exception.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8.2 TS2M0 | 9.4 TS1M0 |